|
This page last changed on Aug 09, 2010 by rosie@atlassian.com.
Limitations on project totals imposed by databases:
| Database |
Limitation |
| Oracle |
1000 |
| SQL Server |
No hard limit as a query can have any number of parameters, as long as it remains within the maximum batch size — which defaults to 65,536 * Network Packet Size (256MB). In practice, however, 2100 is the limit as this is the maximum number of parameters allowed by SQL Server. |
| MySQL |
No hard limit; maximum query size has to be less than max_allowed_packet, which defaults to 1GB, but can be any value in the range 1024-1073741824 Bytes. |
| PostgreSQL |
No hard limits; SQL query size is limited to the OS maximum file size. |
| HSQLDB |
No limits specified, but in practice limited by heap memory. |
|